Model Table DATE CLOSURE/COMPLETED
Attributes
| Attribute | Description (where applicable) |
| Closure Date | |
| Closure Date String | |
| Closure Month | |
| Closure Month No | |
| Closure Month Short | |
| Closure Quarter | |
| Closure Week | |
| Closure Weekday | |
| Closure Weekday No | |
| Closure Year | |
| Closure Year Month | |
| Current Month Flag | |
| Current Year Flag | |
| Last 12 Months Flag | |
| Last 24 Months Flag | |
| Previous Month Flag | |
| Previous Year Flag | |
| Year (Week based) | |
| Hierarchy | Level |
| ClosureDateMFHY | |
| Closure Year |
| Closure Quarter |
| Closure Month |
| Closure Date |
| ClosureDateMSHy | |
| Closure Year |
| Closure Quarter |
| Closure Month |
| ClosureDateWFHY | |
| Year (Week based) |
| Closure Week |
| Closure Date |
| ClosureDateWSHy | |
| Year (Week based) |
| Closure Week |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| DATE CLOSURE/COMPLETED | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |